home *** CD-ROM | disk | FTP | other *** search
/ Cream of the Crop 21 / Cream of the Crop 21 (Terry Blount) (October 1996).iso / business / tdsk3s10.zip / TRKLONG.TXT < prev    next >
Text File  |  1996-08-13  |  46KB  |  201 lines
  1. (Instructions at M1)                        Commodity Trading Log                        Use this form only for long contracts.                                                                            
  2.                         Long Contract                        Active: Yes or No as a note for your file.                                                                            
  3.                                                 Contract: Contract month and year and the symbol.                                                                            
  4.     Active:            Inititial Margin:            Date Bought:    =($A$14)                FTD: Final trading day.                                                                            
  5.     Contract:            Maint. Margin:            Price Bought:                    Season High: Determine and enter.                                                                            
  6.     FTD:            Commission:            Date Liquidated:                    Season Low: Determine and enter.                                                                            
  7.     Season High:            Point Value:            Price Liquidated:                    "50% & 40% Retrace: These are automatically calculated, don't enter."                                                                            
  8.     Season Low:            Starting Acct Bal:            P/L:    =(I7-I5)*F7-F6                Initial Margin: Determine and enter.                                                                            
  9.     50% Retrace    =(C7+C8)/2        Initial Stop Loss:                                Maint. Margin: Determine and enter.                                                                            
  10.     40% Retrace:    =(C9-C8)*0.4+C8        Trail Stop Loss:                                Commission: Determine and enter.                                                                            
  11.                 Target Stop:                                Point Value: Enter the conversion factor required to convert from                                                                             
  12.                             Trading                                          whatever price units you are using to effect on the                                                                             
  13. Date    High    Low    Close    Profit    Profit    Stopped    Account    Margin                                      price of the full contract.                        Margin                                                    
  14.                 High    Low    Out    (Close)    Call    Comments            Starting Acct. Bal: The balance in your trading account when the        Trail    Target    Stop        Call                                                    
  15.                 =(B15-$I$5)*$F$7-$F$6    =(C15-$I$5)*$F$7-$F$6    =(Q15)    =($F$8)+((D15-$I$5)*$F$7)-$F$6    =(S15)                                                  contract is bought.        "=(IF(C15<$F$10,1,0))"    "=(IF(B15>$F$11,1,0))"    "=(IF(OR(O15=1,P15=1),""Out"",""In""))"        "=(IF(H15<$F$5,""Yes"",""No""))"                                                    
  16.                 =(B16-$I$5)*$F$7-$F$6    =(C16-$I$5)*$F$7-$F$6    =(Q16)    =($F$8)+((D16-$I$5)*$F$7)-$F$6    =(S16)                Initial Stop Loss: Decide and enter.        "=(IF(C16<$F$10,1,0))"    "=(IF(B16>$F$11,1,0))"    "=(IF(OR(O16=1,P16=1),""Out"",""In""))"        "=(IF(H16<$F$5,""Yes"",""No""))"                                                    
  17.                 =(B17-$I$5)*$F$7-$F$6    =(C17-$I$5)*$F$7-$F$6    =(Q17)    =($F$8)+((D17-$I$5)*$F$7)-$F$6    =(S17)                "Trailing Stop Loss: Should initially be the same as the ""Initial Stop"        "=(IF(C17<$F$10,1,0))"    "=(IF(B17>$F$11,1,0))"    "=(IF(OR(O17=1,P17=1),""Out"",""In""))"        "=(IF(H17<$F$5,""Yes"",""No""))"
  18.                 =(B18-$I$5)*$F$7-$F$6    =(C18-$I$5)*$F$7-$F$6    =(Q18)    =($F$8)+((D18-$I$5)*$F$7)-$F$6    =(S18)                "                                   Loss"" and then adjust as the price moves in"        "=(IF(C18<$F$10,1,0))"    "=(IF(B18>$F$11,1,0))"    "=(IF(OR(O18=1,P18=1),""Out"",""In""))"        "=(IF(H18<$F$5,""Yes"",""No""))"
  19.                 =(B19-$I$5)*$F$7-$F$6    =(C19-$I$5)*$F$7-$F$6    =(Q19)    =($F$8)+((D19-$I$5)*$F$7)-$F$6    =(S19)                                                   price moves in your favor and according to your        "=(IF(C19<$F$10,1,0))"    "=(IF(B19>$F$11,1,0))"    "=(IF(OR(O19=1,P19=1),""Out"",""In""))"        "=(IF(H19<$F$5,""Yes"",""No""))"
  20.                 =(B20-$I$5)*$F$7-$F$6    =(C20-$I$5)*$F$7-$F$6    =(Q20)    =($F$8)+((D20-$I$5)*$F$7)-$F$6    =(S20)                                                   trailing stop loss policy.        "=(IF(C20<$F$10,1,0))"    "=(IF(B20>$F$11,1,0))"    "=(IF(OR(O20=1,P20=1),""Out"",""In""))"        "=(IF(H20<$F$5,""Yes"",""No""))"
  21.                 =(B21-$I$5)*$F$7-$F$6    =(C21-$I$5)*$F$7-$F$6    =(Q21)    =($F$8)+((D21-$I$5)*$F$7)-$F$6    =(S21)                Target Stop: Use this if you want to liquidate at a specific profit.        "=(IF(C21<$F$10,1,0))"    "=(IF(B21>$F$11,1,0))"    "=(IF(OR(O21=1,P21=1),""Out"",""In""))"        "=(IF(H21<$F$5,""Yes"",""No""))"
  22.                 =(B22-$I$5)*$F$7-$F$6    =(C22-$I$5)*$F$7-$F$6    =(Q22)    =($F$8)+((D22-$I$5)*$F$7)-$F$6    =(S22)                "Date Bought: Enter nothing, this is referenced to the date you open"        "=(IF(C22<$F$10,1,0))"    "=(IF(B22>$F$11,1,0))"    "=(IF(OR(O22=1,P22=1),""Out"",""In""))"        "=(IF(H22<$F$5,""Yes"",""No""))"
  23.                 =(B23-$I$5)*$F$7-$F$6    =(C23-$I$5)*$F$7-$F$6    =(Q23)    =($F$8)+((D23-$I$5)*$F$7)-$F$6    =(S23)                                         the position.        "=(IF(C23<$F$10,1,0))"    "=(IF(B23>$F$11,1,0))"    "=(IF(OR(O23=1,P23=1),""Out"",""In""))"        "=(IF(H23<$F$5,""Yes"",""No""))"
  24.                 =(B24-$I$5)*$F$7-$F$6    =(C24-$I$5)*$F$7-$F$6    =(Q24)    =($F$8)+((D24-$I$5)*$F$7)-$F$6    =(S24)                Price Bought:  Enter the price at which the order was actually executed.        "=(IF(C24<$F$10,1,0))"    "=(IF(B24>$F$11,1,0))"    "=(IF(OR(O24=1,P24=1),""Out"",""In""))"        "=(IF(H24<$F$5,""Yes"",""No""))"
  25.                 =(B25-$I$5)*$F$7-$F$6    =(C25-$I$5)*$F$7-$F$6    =(Q25)    =($F$8)+((D25-$I$5)*$F$7)-$F$6    =(S25)                Date Liquidated: Enter the date you liquidated the contract.        "=(IF(C25<$F$10,1,0))"    "=(IF(B25>$F$11,1,0))"    "=(IF(OR(O25=1,P25=1),""Out"",""In""))"        "=(IF(H25<$F$5,""Yes"",""No""))"
  26.                 =(B26-$I$5)*$F$7-$F$6    =(C26-$I$5)*$F$7-$F$6    =(Q26)    =($F$8)+((D26-$I$5)*$F$7)-$F$6    =(S26)                Price Liquidated: Enter the price at which the contract was actually        "=(IF(C26<$F$10,1,0))"    "=(IF(B26>$F$11,1,0))"    "=(IF(OR(O26=1,P26=1),""Out"",""In""))"        "=(IF(H26<$F$5,""Yes"",""No""))"
  27.                 =(B27-$I$5)*$F$7-$F$6    =(C27-$I$5)*$F$7-$F$6    =(Q27)    =($F$8)+((D27-$I$5)*$F$7)-$F$6    =(S27)                                               liquidated.        "=(IF(C27<$F$10,1,0))"    "=(IF(B27>$F$11,1,0))"    "=(IF(OR(O27=1,P27=1),""Out"",""In""))"        "=(IF(H27<$F$5,""Yes"",""No""))"
  28.                 =(B28-$I$5)*$F$7-$F$6    =(C28-$I$5)*$F$7-$F$6    =(Q28)    =($F$8)+((D28-$I$5)*$F$7)-$F$6    =(S28)                P/L: Enter nothing.  The profit/loss is calculated and includes the        "=(IF(C28<$F$10,1,0))"    "=(IF(B28>$F$11,1,0))"    "=(IF(OR(O28=1,P28=1),""Out"",""In""))"        "=(IF(H28<$F$5,""Yes"",""No""))"
  29.                 =(B29-$I$5)*$F$7-$F$6    =(C29-$I$5)*$F$7-$F$6    =(Q29)    =($F$8)+((D29-$I$5)*$F$7)-$F$6    =(S29)                         commission.        "=(IF(C29<$F$10,1,0))"    "=(IF(B29>$F$11,1,0))"    "=(IF(OR(O29=1,P29=1),""Out"",""In""))"        "=(IF(H29<$F$5,""Yes"",""No""))"
  30.                 =(B30-$I$5)*$F$7-$F$6    =(C30-$I$5)*$F$7-$F$6    =(Q30)    =($F$8)+((D30-$I$5)*$F$7)-$F$6    =(S30)                "Price Data: Paste or enter the Date, High, Low and Close for each"        "=(IF(C30<$F$10,1,0))"    "=(IF(B30>$F$11,1,0))"    "=(IF(OR(O30=1,P30=1),""Out"",""In""))"        "=(IF(H30<$F$5,""Yes"",""No""))"
  31.                 =(B31-$I$5)*$F$7-$F$6    =(C31-$I$5)*$F$7-$F$6    =(Q31)    =($F$8)+((D31-$I$5)*$F$7)-$F$6    =(S31)                                    trading session that the position is open.        "=(IF(C31<$F$10,1,0))"    "=(IF(B31>$F$11,1,0))"    "=(IF(OR(O31=1,P31=1),""Out"",""In""))"        "=(IF(H31<$F$5,""Yes"",""No""))"
  32.                 =(B32-$I$5)*$F$7-$F$6    =(C32-$I$5)*$F$7-$F$6    =(Q32)    =($F$8)+((D32-$I$5)*$F$7)-$F$6    =(S32)                Profit High: Enter nothing.  Calculated by subtracting the price at        "=(IF(C32<$F$10,1,0))"    "=(IF(B32>$F$11,1,0))"    "=(IF(OR(O32=1,P32=1),""Out"",""In""))"        "=(IF(H32<$F$5,""Yes"",""No""))"
  33.                 =(B33-$I$5)*$F$7-$F$6    =(C33-$I$5)*$F$7-$F$6    =(Q33)    =($F$8)+((D33-$I$5)*$F$7)-$F$6    =(S33)                                      which you bought the contract from the trading session        "=(IF(C33<$F$10,1,0))"    "=(IF(B33>$F$11,1,0))"    "=(IF(OR(O33=1,P33=1),""Out"",""In""))"        "=(IF(H33<$F$5,""Yes"",""No""))"
  34.                 =(B34-$I$5)*$F$7-$F$6    =(C34-$I$5)*$F$7-$F$6    =(Q34)    =($F$8)+((D34-$I$5)*$F$7)-$F$6    =(S34)                "                      high, multiplying by the point value and then subtracting"        "=(IF(C34<$F$10,1,0))"    "=(IF(B34>$F$11,1,0))"    "=(IF(OR(O34=1,P34=1),""Out"",""In""))"        "=(IF(H34<$F$5,""Yes"",""No""))"
  35.                 =(B35-$I$5)*$F$7-$F$6    =(C35-$I$5)*$F$7-$F$6    =(Q35)    =($F$8)+((D35-$I$5)*$F$7)-$F$6    =(S35)                                      the commission.        "=(IF(C35<$F$10,1,0))"    "=(IF(B35>$F$11,1,0))"    "=(IF(OR(O35=1,P35=1),""Out"",""In""))"        "=(IF(H35<$F$5,""Yes"",""No""))"
  36.                 =(B36-$I$5)*$F$7-$F$6    =(C36-$I$5)*$F$7-$F$6    =(Q36)    =($F$8)+((D36-$I$5)*$F$7)-$F$6    =(S36)                Profit Low: Enter nothing.  Calculated by subtracting the price at        "=(IF(C36<$F$10,1,0))"    "=(IF(B36>$F$11,1,0))"    "=(IF(OR(O36=1,P36=1),""Out"",""In""))"        "=(IF(H36<$F$5,""Yes"",""No""))"
  37.                 =(B37-$I$5)*$F$7-$F$6    =(C37-$I$5)*$F$7-$F$6    =(Q37)    =($F$8)+((D37-$I$5)*$F$7)-$F$6    =(S37)                                      which you bought the contract from the trading session        "=(IF(C37<$F$10,1,0))"    "=(IF(B37>$F$11,1,0))"    "=(IF(OR(O37=1,P37=1),""Out"",""In""))"        "=(IF(H37<$F$5,""Yes"",""No""))"
  38.                 =(B38-$I$5)*$F$7-$F$6    =(C38-$I$5)*$F$7-$F$6    =(Q38)    =($F$8)+((D38-$I$5)*$F$7)-$F$6    =(S38)                "                      low, multipying by the point